<?php

class MeasurementController extends RestController {

	/**
	 * @var string the default layout for the views.
	 *   Defaults to '//layouts/column2', meaning using two-column layout.
	 *   See 'protected/views/layouts/column2.php'.
	 */
	public $layout = '//layouts/column2';

	/**
	 * @return array action filters
	 */
	public function filters() {
		return array(
			'accessControl', // perform access control for CRUD operations
		);
	}

	/**
	 * Specifies the access control rules.
	 * This method is used by the 'accessControl' filter.
	 * @return array access control rules
	 */
	public function _accessRules() {
		return array(
			array(
				'allow',
				'actions'=>array(
					'index',
					'view',
					'save',
					'customRestPostBulk',
				),
				'users'=>array('*'),
			),
			array(
				'allow',
				'actions'=>array(
					'create',
					'update',
					'reportDetailPeriodic',
				),
				'users'=>array('@'),
			),
			array(
				'allow',
				'actions'=>array('admin', 'delete'),
				'users'=>array('admin'),
			),
			array(
				'deny',
				'users'=>array('*'),
			),
		);
	}

	/**
	 * Displays a particular model.
	 * @param integer $id the ID of the model to be displayed
	 */
	public function actionView($id) {
		$data = array(
			'model'=>$this->loadModel($id),
		);
		$this->render('view', $data);
	}

	/**
	 * Creates a new model.
	 * If creation is successful, the browser will be redirected to the 'view'
	 * page.
	 */
	public function actionCreate() {
		$model = new Measurement;

		// $this->performAjaxValidation($model);

		if (isset($_POST['Measurement'])) {
			$model->attributes = $_POST['Measurement'];
			if ($model->save()) {
				$this->redirect(array('view', 'id'=>$model->id));
			}
		}

		$data = array(
			'model'=>$model,
		);
		$this->render('create', $data);
	}

	/**
	 * Updates a particular model.
	 * If update is successful, the browser will be redirected to the 'view'
	 * page.
	 * @param integer $id the ID of the model to be updated
	 */
	public function actionUpdate($id) {
		$model = $this->loadModel($id);

		// $this->performAjaxValidation($model);

		if (isset($_POST['Measurement'])) {
			$model->attributes = $_POST['Measurement'];
			if ($model->save()) {
				$this->redirect(array('view', 'id'=>$model->id));
			}
		}

		$data = array(
			'model'=>$model,
		);
		$this->render('update', $data);
	}

	/**
	 * Deletes a particular model.
	 * If deletion is successful, the browser will be redirected to the 'admin'
	 *   page.
	 * @param integer $id the ID of the model to be deleted
	 */
	public function actionDelete($id) {
		if (Yii::app()->request->isPostRequest) {
			$this->loadModel($id)->delete();

			if (!isset($_GET['ajax'])) {
				$isset = isset($_POST['returnUrl']);
				$this->redirect($isset ? $_POST['returnUrl'] : array('admin'));
			}
		} else {
			$message = 'Invalid request. ';
			$message .= 'Please do not repeat this request again.';
			throw new CHttpException(400, $message);
		}
	}

	/**
	 * Lists all models.
	 */
	public function actionIndex() {
		$dataProvider = new CActiveDataProvider('Measurement');
		$data = array(
			'dataProvider'=>$dataProvider,
		);
		$this->render('index', $data);
	}

	/**
	 * Manages all models.
	 */
	public function actionAdmin() {
		$model = new Measurement('search');
		$model->unsetAttributes();
		if (isset($_GET['Measurement'])) {
			$model->attributes = $_GET['Measurement'];
		}

		$data = array(
			'model'=>$model,
		);
		$this->render('admin', $data);
	}

	/**
	 * Returns the data model based on the primary key given in the GET
	 * variable.
	 * If the data model is not found, an HTTP exception will be raised.
	 * @param integer the ID of the model to be loaded
	 */
	public function loadModel($id) {
		$model = Measurement::model()->findByPk($id);
		if ($model === null) {
			$message = 'The requested page does not exist.';
			throw new CHttpException(404, $message);
		}
		return $model;
	}

	/**
	 * Performs the AJAX validation.
	 * @param CModel the model to be validated
	 */
	protected function performAjaxValidation($model) {
		if (isset($_POST['ajax']) && $_POST['ajax'] === 'measurement-form') {
			echo CActiveForm::validate($model);
			Yii::app()->end();
		}
	}
	
	public function doCustomRestPostBulk($data) {
		$data = array();
		$trans = Yii::app()->db->beginTransaction();
		$measurement = new Measurement;
		$measurement->attributes = $_POST['Measurement'];
		$saved = $measurement->save();
		$data['Measurement'] = $measurement;
		$data['MeasurementChannel'] = array();
		foreach ($_POST['MeasurementChannel'] as $each) {
			$channel = new MeasurementChannel;
			$channel->attributes = $each;
			$saved = $measurement->addChannel($channel) && $saved;
			$data['MeasurementChannel'][] = $channel;
		}
		if ($saved) {
			$trans->commit();
		} else {
			$data = array();
			$trans->rollBack();
			$this->HTTPStatus = $this->getHttpStatus('406');
		}
		$this->renderJson($data);
	}
	
	public function actionReportDetailPeriodic() {
		set_time_limit(0);
		$this->layout = '//layouts/column1';
		
		$model = new Measurement('search');
		$model->unsetAttributes();
		
		$channels = array();
		$models = Channel::model()->findAll();
		foreach ($models as $channel) {
			$channels[$channel->sequence] = $channel;
		}
		
		if (isset($_GET['Measurement'])) {
			$model->attributes = $_GET['Measurement'];
			
			if (isset($_GET['download'])) {
				$criteria = new CDbCriteria;
				$criteria->compare('deviceSequence', $model->deviceSequence);
				$first = $model->firstDateTime;
				$last = $model->lastDateTime;
				if (!empty($first) && !empty($last)) {
					$criteria->addBetweenCondition('createdAt', $first, $last);
				}
				
				$config = array(
					'criteria'=>$criteria,
				);
				$provider = new CActiveDataProvider('Measurement', $config);
				
				$csv = new CsvExport($provider);
				$csv->setCallback(array($this, 'reportDetailPeriodicCallback'));
				
				$headers = array(
					'Time',
					'Location',
				);
				for ($i = 1; $i <= 8; $i++) {
					$header = $i;
					$invisible = false;
					if (array_key_exists($i, $channels)) {
						$header = $channels[$i]->name;
						$invisible = $channels[$i]->invisible;
					}
					if ($invisible) continue;
					
					$headers[] = $header;
				}
				
				$csv->download('Measurement.csv', $headers);
			}
		}
		
		$devices = Device::model()->findAll();
		$deviceList = CHtml::listData($devices, 'sequence', 'name');
		
		$data = array(
			'model'=>$model,
			'channels'=>$channels,
			'deviceList'=>$deviceList,
		);
		$this->render('reports/details/periodic', $data);
	}
	
	public function reportDetailPeriodicCallback($row) {
		$withs = array('channels', 'channels.channel', 'device');
		$measurement = Measurement::model()->with($withs)->findByPk($row['id']);
		$data = array(
			'createdAt'=>$measurement->createdAt,
			'location'=>$measurement->device ? $measurement->device->name : '',
		);
		$channels = $measurement->arrayChannels;
		for ($i = 1; $i <= 8; $i++) {
			if (!$channels[$i]['invisible']) $data[] = $channels[$i]['cute'];
		}
		return $data;
	}
	
}
